package cn.nawang.ebeim.test.constants;

/**
 * Created by GanJc on 2015-12-08 11:46
 */
public class InitSql {

    public final static String CREATE_ROOT_TABLE =
            "CREATE TABLE if not exists root(\n" +
                    "id integer primary key autoincrement,\n" +
                    "root_path varchar(100),\n" +
                    "abs_path varchar(100),\n" +
                    "total_dir integer,\n" +
                    "total_file integer\n" +
                    ");";

    public final static String CREATE_FILE_TABLE =
            "CREATE TABLE if not exists file_info(\n" +
                    "id integer primary key autoincrement,\n" +
                    "container varchar(200),\n" +
                    "signature varchar(200),\n" +
                    "file_path varchar(200),\n" +
                    "root_path varchar(100),\n" +
                    "abs_path varchar(100)\n" +
                    ");";
}
